IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_GameEnrollmentLog')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_GameEnrollmentLog
  END
  
CREATE TABLE [dbo].[CGO_GameEnrollmentLog]
(
[EnrollmentLogID] [int] NOT NULL IDENTITY(1, 1),
[EnrollmentID] [int] NOT NULL,
[Action] [nvarchar](100) NULL ,
[StatusBefore] [nvarchar](100) NULL ,
[StatusAfter] [nvarchar](100) NULL ,
[LogTime] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CGO_GameEnrollmentLog] ADD CONSTRAINT [PK_CGO_GameEnrollmentLog] PRIMARY KEY CLUSTERED  ([EnrollmentLogID]) ON [PRIMARY]
GO